# coding=utf8

import sys

from openpyxl.reader.excel import load_workbook

reload(sys)
sys.setdefaultencoding('utf-8')


def process(work_book):
    wb = load_workbook(filename=work_book)
    ws = wb.worksheets[0]
    remember = ''
    for r in range(1, ws.max_row + 1):
        tmp = str(ws.cell(row=r, column=1).value).strip()
        if tmp != 'None':
            remember = tmp
        ws.cell(row=r, column=1).value = remember
    wb.save(work_book)

